<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@page import="java.sql.*" %>
<%request.setCharacterEncoding("utf-8");%>
<%String id=request.getParameter("stuid");%>
<%String stuName= request.getParameter("stuname");%>
<%String stuBirthday=request.getParameter("stubirthday");%>
<%String stuClass=request.getParameter("stuclass");%>
<head>
    <title>修改结果</title>
  <%! ResultSet rs;%>
  <%
    String dbName = "school";//数据库
    String userName ="root";//账户
    String userPassword ="qwert";//密码
    String url ="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPassword;
    Class.forName("com.mysql.cj.jdbc.Driver");//5.7以下不加.cj
    Connection conn = DriverManager.getConnection(url);//连接数据库
    String sql = "update student set birthday=?,stuclass=?where number=?";
    PreparedStatement preparedStatement= conn.prepareStatement(sql);//创建操作对象
    preparedStatement.setString(1,stuBirthday);
    preparedStatement.setString(2,stuClass);
    preparedStatement.setString(3,id);
    int rsult = preparedStatement.executeUpdate();//运行sql命令查询数据 结果放到rs结果集中
    if (rsult>0){
      out.print("<script type='text/javascript'>alert('修改成功')</script>");
    }else {
      out.print("<script type='text/javascript'>alert('修改失败')</script>");
    }
    sql = "select  * from student";
    rs = preparedStatement.executeQuery(sql);
  %>

</head>
<html>
<body>
<table border="1">
  <th colpan="4" style="font-size: x-large;alignment:center">学生表信息</th>
  <tr style="text-align: center">
    <td>学号</td>
    <td>姓名</td>
    <td>出生日期</td>
    <td>所在班级</td>
  </tr>
  <% while (rs.next()){%>
  <tr style="text-align: center">
    <td><%=rs.getString(1) %></td>
    <td><%=rs.getString(2) %></td>
    <td><%=rs.getString(3) %></td>
    <td><%=rs.getString(4) %></td>
  </tr>
  <% } %>
  <%
    rs.close();
    preparedStatement.close();
    conn.close();
  %>
</table>
</body>
</html>
